Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 7049 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 6 |
|---|---|
| DateTime | 3 |
| Categorical | 9 |
| Numeric | 7 |
age_category is highly overall correlated with age_of_patient and 4 other fields | High correlation |
age_of_patient is highly overall correlated with age_category and 1 other fields | High correlation |
base_encounter_cost is highly overall correlated with description and 1 other fields | High correlation |
code is highly overall correlated with age_category and 2 other fields | High correlation |
description is highly overall correlated with age_category and 3 other fields | High correlation |
encounter_class is highly overall correlated with base_encounter_cost and 2 other fields | High correlation |
income is highly overall correlated with income_category | High correlation |
income_category is highly overall correlated with income and 1 other fields | High correlation |
marital is highly overall correlated with age_category and 1 other fields | High correlation |
payer_coverage is highly overall correlated with total_claim_cost | High correlation |
payer_id is highly overall correlated with age_category and 1 other fields | High correlation |
total_claim_cost is highly overall correlated with payer_coverage | High correlation |
ethnicity is highly imbalanced (55.0%) | Imbalance |
code is highly skewed (γ1 = 59.35486139) | Skewed |
length_of_stay_hours is highly skewed (γ1 = 31.33577056) | Skewed |
encounter_id has unique values | Unique |
payer_coverage has 1930 (27.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-02 13:19:58.107990 |
|---|---|
| Analysis finished | 2024-12-02 13:20:08.064216 |
| Duration | 9.96 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
encounter_id
Text
Unique 
| Distinct | 7049 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 7049 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 294d0dab-907e-8fce-7a47-0c0d322a5734 |
|---|---|
| 2nd row | 2ccec874-cbaa-e280-7abb-f2bc2b603961 |
| 3rd row | 953c5138-ce17-4084-3432-1ac23f184528 |
| 4th row | 17dd3b88-0b85-2b6f-c342-c9d6cf5315cb |
| 5th row | 0b03e41b-06a6-66fa-b972-acc5a83b134a |
| Value | Count | Frequency (%) |
| d1cea2e5-1735-089f-c72f-22ad16976663 | 1 | < 0.1% |
| 8fb043ba-08be-2a3a-1011-c3019f2b7d07 | 1 | < 0.1% |
| 294d0dab-907e-8fce-7a47-0c0d322a5734 | 1 | < 0.1% |
| 2ccec874-cbaa-e280-7abb-f2bc2b603961 | 1 | < 0.1% |
| 953c5138-ce17-4084-3432-1ac23f184528 | 1 | < 0.1% |
| 17dd3b88-0b85-2b6f-c342-c9d6cf5315cb | 1 | < 0.1% |
| 0b03e41b-06a6-66fa-b972-acc5a83b134a | 1 | < 0.1% |
| 1617912a-d228-1f6c-ed9b-d8fb39ef0a32 | 1 | < 0.1% |
| 3606e65a-a4da-810c-ef6b-ddbf6da17952 | 1 | < 0.1% |
| ab6384eb-f097-86af-81c7-dda8af228f77 | 1 | < 0.1% |
| Other values (7039) | 7039 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| c | 14291 | 5.6% |
| b | 14275 | 5.6% |
| 7 | 14271 | 5.6% |
| 0 | 14244 | 5.6% |
| d | 14158 | 5.6% |
| 2 | 14114 | 5.6% |
| a | 14101 | 5.6% |
| 4 | 14086 | 5.6% |
| f | 14069 | 5.5% |
| Other values (7) | 97959 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| c | 14291 | 5.6% |
| b | 14275 | 5.6% |
| 7 | 14271 | 5.6% |
| 0 | 14244 | 5.6% |
| d | 14158 | 5.6% |
| 2 | 14114 | 5.6% |
| a | 14101 | 5.6% |
| 4 | 14086 | 5.6% |
| f | 14069 | 5.5% |
| Other values (7) | 97959 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| c | 14291 | 5.6% |
| b | 14275 | 5.6% |
| 7 | 14271 | 5.6% |
| 0 | 14244 | 5.6% |
| d | 14158 | 5.6% |
| 2 | 14114 | 5.6% |
| a | 14101 | 5.6% |
| 4 | 14086 | 5.6% |
| f | 14069 | 5.5% |
| Other values (7) | 97959 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| c | 14291 | 5.6% |
| b | 14275 | 5.6% |
| 7 | 14271 | 5.6% |
| 0 | 14244 | 5.6% |
| d | 14158 | 5.6% |
| 2 | 14114 | 5.6% |
| a | 14101 | 5.6% |
| 4 | 14086 | 5.6% |
| f | 14069 | 5.5% |
| Other values (7) | 97959 |
start_time
Date
| Distinct | 7014 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| Minimum | 1931-04-21 11:59:06 |
|---|---|
| Maximum | 2024-11-04 08:21:17 |
stop_time
Date
| Distinct | 7045 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| Minimum | 1931-04-21 12:19:24 |
|---|---|
| Maximum | 2024-11-05 00:34:10 |
patient_id
Text
| Distinct | 106 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
|---|---|
| 2nd row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| 3rd row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| 4th row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| 5th row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| Value | Count | Frequency (%) |
| 4f159375-4ee4-36ab-b464-6d38f6ff2dae | 700 | 9.9% |
| d1622e8b-d26b-ec81-ffcb-ec4bf2af385b | 691 | 9.8% |
| d27273f0-f62d-7d7f-746d-4565f35cf176 | 546 | 7.7% |
| 655baba7-47ed-22ac-2093-1196ebb44928 | 393 | 5.6% |
| cb1b46a1-9cb5-1187-ccc5-9fb7b98aa957 | 252 | 3.6% |
| f3884e8a-8b36-1e93-66dd-e910dfab2ef5 | 248 | 3.5% |
| bad5a231-3709-952a-cf44-f8d6a52cc214 | 243 | 3.4% |
| 14dc5e57-1b84-3305-c042-86c9fc7e4996 | 141 | 2.0% |
| 17e0bdef-4558-cc1d-2d44-90868cad827b | 115 | 1.6% |
| 65016a46-14f4-d19a-f82f-10299aba4c14 | 99 | 1.4% |
| Other values (96) | 3621 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| f | 17548 | 6.9% |
| 6 | 16408 | 6.5% |
| 4 | 15945 | 6.3% |
| 2 | 15897 | 6.3% |
| b | 15779 | 6.2% |
| e | 14615 | 5.8% |
| d | 14534 | 5.7% |
| 7 | 14034 | 5.5% |
| 5 | 13986 | 5.5% |
| Other values (7) | 86822 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| f | 17548 | 6.9% |
| 6 | 16408 | 6.5% |
| 4 | 15945 | 6.3% |
| 2 | 15897 | 6.3% |
| b | 15779 | 6.2% |
| e | 14615 | 5.8% |
| d | 14534 | 5.7% |
| 7 | 14034 | 5.5% |
| 5 | 13986 | 5.5% |
| Other values (7) | 86822 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| f | 17548 | 6.9% |
| 6 | 16408 | 6.5% |
| 4 | 15945 | 6.3% |
| 2 | 15897 | 6.3% |
| b | 15779 | 6.2% |
| e | 14615 | 5.8% |
| d | 14534 | 5.7% |
| 7 | 14034 | 5.5% |
| 5 | 13986 | 5.5% |
| Other values (7) | 86822 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| f | 17548 | 6.9% |
| 6 | 16408 | 6.5% |
| 4 | 15945 | 6.3% |
| 2 | 15897 | 6.3% |
| b | 15779 | 6.2% |
| e | 14615 | 5.8% |
| d | 14534 | 5.7% |
| 7 | 14034 | 5.5% |
| 5 | 13986 | 5.5% |
| Other values (7) | 86822 |
organization_id
Text
| Distinct | 251 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | f2068cee-c75c-321d-9b2c-c33535db89c9 |
|---|---|
| 2nd row | f2068cee-c75c-321d-9b2c-c33535db89c9 |
| 3rd row | db106514-f254-3402-b6a4-6d210c78c7e2 |
| 4th row | f8918a95-31e8-3ac4-8d12-29ca6080ebda |
| 5th row | f2068cee-c75c-321d-9b2c-c33535db89c9 |
| Value | Count | Frequency (%) |
| 6170552c-4d27-3e64-8068-64a380f1837d | 717 | 10.2% |
| 0d1570ab-371c-3898-9397-95905d8c5166 | 646 | 9.2% |
| ce4d0501-49eb-396a-bc56-545fdfc624b0 | 566 | 8.0% |
| 38508743-50d1-3429-8fe2-37e42ddaf20e | 485 | 6.9% |
| c272e12f-e154-3fee-b05d-b7c0cab2657d | 205 | 2.9% |
| 845fbd9b-2d1c-39a8-8261-28ae40e4fab2 | 183 | 2.6% |
| 2836d9ac-c6a6-39d1-8f13-fdf0fc8928f4 | 165 | 2.3% |
| e59fb2d5-508c-38c6-af2e-21d8216dd2b0 | 160 | 2.3% |
| 5018c664-e283-30eb-932a-529d9a19b3b5 | 125 | 1.8% |
| ea8d287f-b3a9-3800-8798-788e334ee406 | 107 | 1.5% |
| Other values (241) | 3690 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 18351 | 7.2% |
| 8 | 17255 | 6.8% |
| 0 | 16782 | 6.6% |
| 5 | 15616 | 6.2% |
| 6 | 14478 | 5.7% |
| d | 14345 | 5.7% |
| 9 | 14139 | 5.6% |
| 4 | 13966 | 5.5% |
| 2 | 13725 | 5.4% |
| Other values (7) | 86911 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 18351 | 7.2% |
| 8 | 17255 | 6.8% |
| 0 | 16782 | 6.6% |
| 5 | 15616 | 6.2% |
| 6 | 14478 | 5.7% |
| d | 14345 | 5.7% |
| 9 | 14139 | 5.6% |
| 4 | 13966 | 5.5% |
| 2 | 13725 | 5.4% |
| Other values (7) | 86911 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 18351 | 7.2% |
| 8 | 17255 | 6.8% |
| 0 | 16782 | 6.6% |
| 5 | 15616 | 6.2% |
| 6 | 14478 | 5.7% |
| d | 14345 | 5.7% |
| 9 | 14139 | 5.6% |
| 4 | 13966 | 5.5% |
| 2 | 13725 | 5.4% |
| Other values (7) | 86911 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 18351 | 7.2% |
| 8 | 17255 | 6.8% |
| 0 | 16782 | 6.6% |
| 5 | 15616 | 6.2% |
| 6 | 14478 | 5.7% |
| d | 14345 | 5.7% |
| 9 | 14139 | 5.6% |
| 4 | 13966 | 5.5% |
| 2 | 13725 | 5.4% |
| Other values (7) | 86911 |
provider_id
Text
| Distinct | 251 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | c3d07214-c20f-3f33-ad41-0e55adf5b024 |
|---|---|
| 2nd row | c3d07214-c20f-3f33-ad41-0e55adf5b024 |
| 3rd row | 2c4b7d17-0ded-3e16-b5eb-6dda1d6a81bb |
| 4th row | b4d9fbc9-fdca-369d-bbba-019479923f08 |
| 5th row | c3d07214-c20f-3f33-ad41-0e55adf5b024 |
| Value | Count | Frequency (%) |
| 5cbe7b88-71ba-3b7c-b027-ab8324c29eef | 717 | 10.2% |
| 8ba9dc63-e8c2-383a-9031-314602010985 | 646 | 9.2% |
| d946aa55-e4bc-3444-a5e2-1333c809aed2 | 566 | 8.0% |
| ab0d6460-0522-3dd7-a8a9-8dffa8b3cd1d | 485 | 6.9% |
| 5dfdc01b-32a6-35ad-84b1-9bbfebcd55a4 | 205 | 2.9% |
| e25d4fb8-95fd-396b-bd2a-974be06b00fc | 183 | 2.6% |
| 3b55f437-786a-34f2-9c07-8dd10fdae467 | 165 | 2.3% |
| c9b58d6b-45da-3a51-8644-8fcee6382e1d | 160 | 2.3% |
| 3ea4ea33-cbe6-3f5f-a6fb-253ecdd58071 | 125 | 1.8% |
| 465384bd-0282-3ed1-8329-bc70c094a505 | 107 | 1.5% |
| Other values (241) | 3690 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 20801 | 8.2% |
| b | 17668 | 7.0% |
| a | 17398 | 6.9% |
| 8 | 15829 | 6.2% |
| 2 | 14261 | 5.6% |
| d | 14089 | 5.6% |
| 9 | 14026 | 5.5% |
| 5 | 13573 | 5.3% |
| 0 | 13150 | 5.2% |
| Other values (7) | 84773 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 20801 | 8.2% |
| b | 17668 | 7.0% |
| a | 17398 | 6.9% |
| 8 | 15829 | 6.2% |
| 2 | 14261 | 5.6% |
| d | 14089 | 5.6% |
| 9 | 14026 | 5.5% |
| 5 | 13573 | 5.3% |
| 0 | 13150 | 5.2% |
| Other values (7) | 84773 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 20801 | 8.2% |
| b | 17668 | 7.0% |
| a | 17398 | 6.9% |
| 8 | 15829 | 6.2% |
| 2 | 14261 | 5.6% |
| d | 14089 | 5.6% |
| 9 | 14026 | 5.5% |
| 5 | 13573 | 5.3% |
| 0 | 13150 | 5.2% |
| Other values (7) | 84773 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | 11.1% |
| 3 | 20801 | 8.2% |
| b | 17668 | 7.0% |
| a | 17398 | 6.9% |
| 8 | 15829 | 6.2% |
| 2 | 14261 | 5.6% |
| d | 14089 | 5.6% |
| 9 | 14026 | 5.5% |
| 5 | 13573 | 5.3% |
| 0 | 13150 | 5.2% |
| Other values (7) | 84773 |
payer_id
Categorical
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| a735bf55-83e9-331a-899d-a82a60b9f60c | |
|---|---|
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | |
| df166300-5a78-3502-a46a-832842197811 | |
| 26aab0cd-6aba-3e1b-ac5b-05c8867e762c | |
| b046940f-1664-3047-bca7-dfa76be352a4 | |
| Other values (5) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | d31fccc3-1767-390d-966a-22a5156f4219 |
|---|---|
| 2nd row | d31fccc3-1767-390d-966a-22a5156f4219 |
| 3rd row | d31fccc3-1767-390d-966a-22a5156f4219 |
| 4th row | d31fccc3-1767-390d-966a-22a5156f4219 |
| 5th row | d31fccc3-1767-390d-966a-22a5156f4219 |
Common Values
| Value | Count | Frequency (%) |
| a735bf55-83e9-331a-899d-a82a60b9f60c | 3155 | |
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | 759 | 10.8% |
| df166300-5a78-3502-a46a-832842197811 | 725 | 10.3% |
| 26aab0cd-6aba-3e1b-ac5b-05c8867e762c | 613 | 8.7% |
| b046940f-1664-3047-bca7-dfa76be352a4 | 566 | 8.0% |
| d31fccc3-1767-390d-966a-22a5156f4219 | 424 | 6.0% |
| 0133f751-9229-3cfd-815f-b6d4979bdd6a | 346 | 4.9% |
| 8fa6c185-e44e-3e34-8bd8-39be8694f4ce | 220 | 3.1% |
| 734afbd6-4794-363b-9bc0-6a3981533ed5 | 176 | 2.5% |
| d18ef2e6-ef40-324c-be54-34a5ee865625 | 65 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a735bf55-83e9-331a-899d-a82a60b9f60c | 3155 | |
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | 759 | 10.8% |
| df166300-5a78-3502-a46a-832842197811 | 725 | 10.3% |
| 26aab0cd-6aba-3e1b-ac5b-05c8867e762c | 613 | 8.7% |
| b046940f-1664-3047-bca7-dfa76be352a4 | 566 | 8.0% |
| d31fccc3-1767-390d-966a-22a5156f4219 | 424 | 6.0% |
| 0133f751-9229-3cfd-815f-b6d4979bdd6a | 346 | 4.9% |
| 8fa6c185-e44e-3e34-8bd8-39be8694f4ce | 220 | 3.1% |
| 734afbd6-4794-363b-9bc0-6a3981533ed5 | 176 | 2.5% |
| d18ef2e6-ef40-324c-be54-34a5ee865625 | 65 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 28196 | |
| 3 | 23732 | 9.4% |
| a | 22148 | 8.7% |
| 9 | 19053 | 7.5% |
| 6 | 19029 | 7.5% |
| 0 | 15456 | 6.1% |
| 8 | 15343 | 6.0% |
| 5 | 15079 | 5.9% |
| f | 13076 | 5.2% |
| b | 12944 | 5.1% |
| Other values (7) | 69708 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | |
| 3 | 23732 | 9.4% |
| a | 22148 | 8.7% |
| 9 | 19053 | 7.5% |
| 6 | 19029 | 7.5% |
| 0 | 15456 | 6.1% |
| 8 | 15343 | 6.0% |
| 5 | 15079 | 5.9% |
| f | 13076 | 5.2% |
| b | 12944 | 5.1% |
| Other values (7) | 69708 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | |
| 3 | 23732 | 9.4% |
| a | 22148 | 8.7% |
| 9 | 19053 | 7.5% |
| 6 | 19029 | 7.5% |
| 0 | 15456 | 6.1% |
| 8 | 15343 | 6.0% |
| 5 | 15079 | 5.9% |
| f | 13076 | 5.2% |
| b | 12944 | 5.1% |
| Other values (7) | 69708 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 28196 | |
| 3 | 23732 | 9.4% |
| a | 22148 | 8.7% |
| 9 | 19053 | 7.5% |
| 6 | 19029 | 7.5% |
| 0 | 15456 | 6.1% |
| 8 | 15343 | 6.0% |
| 5 | 15079 | 5.9% |
| f | 13076 | 5.2% |
| b | 12944 | 5.1% |
| Other values (7) | 69708 |
encounter_class
Categorical
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| ambulatory | |
|---|---|
| wellness | |
| outpatient | |
| urgentcare | 313 |
| emergency | 246 |
| Other values (5) | 108 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.556391 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | wellness |
|---|---|
| 2nd row | wellness |
| 3rd row | emergency |
| 4th row | ambulatory |
| 5th row | wellness |
Common Values
| Value | Count | Frequency (%) |
| ambulatory | 4117 | |
| wellness | 1281 | 18.2% |
| outpatient | 984 | 14.0% |
| urgentcare | 313 | 4.4% |
| emergency | 246 | 3.5% |
| inpatient | 56 | 0.8% |
| home | 21 | 0.3% |
| virtual | 12 | 0.2% |
| snf | 11 | 0.2% |
| hospice | 8 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ambulatory | 4117 | |
| wellness | 1281 | 18.2% |
| outpatient | 984 | 14.0% |
| urgentcare | 313 | 4.4% |
| emergency | 246 | 3.5% |
| inpatient | 56 | 0.8% |
| home | 21 | 0.3% |
| virtual | 12 | 0.2% |
| snf | 11 | 0.2% |
| hospice | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9599 | |
| t | 7506 | |
| l | 6691 | |
| u | 5426 | |
| o | 5130 | |
| r | 5001 | |
| e | 4995 | |
| m | 4384 | |
| y | 4363 | |
| b | 4117 | |
| Other values (10) | 10151 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 67363 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 9599 | |
| t | 7506 | |
| l | 6691 | |
| u | 5426 | |
| o | 5130 | |
| r | 5001 | |
| e | 4995 | |
| m | 4384 | |
| y | 4363 | |
| b | 4117 | |
| Other values (10) | 10151 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 67363 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 9599 | |
| t | 7506 | |
| l | 6691 | |
| u | 5426 | |
| o | 5130 | |
| r | 5001 | |
| e | 4995 | |
| m | 4384 | |
| y | 4363 | |
| b | 4117 | |
| Other values (10) | 10151 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 67363 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 9599 | |
| t | 7506 | |
| l | 6691 | |
| u | 5426 | |
| o | 5130 | |
| r | 5001 | |
| e | 4995 | |
| m | 4384 | |
| y | 4363 | |
| b | 4117 | |
| Other values (10) | 10151 |
code
Real number (ℝ)
High correlation  Skewed 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.288151 × 1011 |
| Minimum | 1505002 |
|---|---|
| Maximum | 4.53131 × 1014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 1505002 |
|---|---|
| 5-th percentile | 1.62673 × 108 |
| Q1 | 1.85347 × 108 |
| median | 1.85347 × 108 |
| Q3 | 3.0833501 × 108 |
| 95-th percentile | 6.98314 × 108 |
| Maximum | 4.53131 × 1014 |
| Range | 4.53131 × 1014 |
| Interquartile range (IQR) | 1.2298801 × 108 |
Descriptive statistics
| Standard deviation | 7.6320985 × 1012 |
|---|---|
| Coefficient of variation (CV) | 59.248478 |
| Kurtosis | 3521.9989 |
| Mean | 1.288151 × 1011 |
| Median Absolute Deviation (MAD) | 2002 |
| Skewness | 59.354861 |
| Sum | 9.0801762 × 1014 |
| Variance | 5.8248927 × 1025 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 185347001 | 2371 | |
| 185349003 | 1207 | |
| 162673000 | 843 | 12.0% |
| 410620009 | 432 | 6.1% |
| 185345009 | 361 | 5.1% |
| 424619006 | 318 | 4.5% |
| 702927004 | 311 | 4.4% |
| 308335008 | 226 | 3.2% |
| 33879002 | 136 | 1.9% |
| 698314001 | 135 | 1.9% |
| Other values (35) | 709 | 10.1% |
| Value | Count | Frequency (%) |
| 1505002 | 1 | < 0.1% |
| 32485007 | 21 | 0.3% |
| 33879002 | 136 | 1.9% |
| 50849002 | 130 | 1.8% |
| 56876005 | 7 | 0.1% |
| 79094001 | 2 | < 0.1% |
| 86013001 | 2 | < 0.1% |
| 162673000 | 843 | |
| 169762003 | 35 | 0.5% |
| 170837001 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.531310001 × 1014 | 2 | < 0.1% |
| 702927004 | 311 | |
| 698314001 | 135 | 1.9% |
| 439740005 | 43 | 0.6% |
| 439708006 | 21 | 0.3% |
| 424619006 | 318 | |
| 424441002 | 52 | 0.7% |
| 410620009 | 432 | |
| 410410006 | 7 | 0.1% |
| 397821002 | 1 | < 0.1% |
description
Categorical
High correlation 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| Encounter for problem (procedure) | |
|---|---|
| Encounter for check up (procedure) | |
| General examination of patient (procedure) | |
| Well child visit (procedure) | |
| Encounter for symptom (procedure) | |
| Other values (40) |
Length
| Max length | 75 |
|---|---|
| Median length | 70 |
| Mean length | 34.982693 |
| Min length | 19 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | General examination of patient (procedure) |
|---|---|
| 2nd row | General examination of patient (procedure) |
| 3rd row | Emergency room admission (procedure) |
| 4th row | Encounter for check up (procedure) |
| 5th row | General examination of patient (procedure) |
Common Values
| Value | Count | Frequency (%) |
| Encounter for problem (procedure) | 2371 | |
| Encounter for check up (procedure) | 1207 | |
| General examination of patient (procedure) | 843 | 12.0% |
| Well child visit (procedure) | 432 | 6.1% |
| Encounter for symptom (procedure) | 361 | 5.1% |
| Prenatal visit (regime/therapy) | 318 | 4.5% |
| Urgent care clinic (environment) | 311 | 4.4% |
| Patient encounter procedure (procedure) | 226 | 3.2% |
| Administration of vaccine to produce active immunity (procedure) | 136 | 1.9% |
| Consultation for treatment (procedure) | 135 | 1.9% |
| Other values (35) | 709 | 10.1% |
Length
| Value | Count | Frequency (%) |
| procedure | 6565 | |
| encounter | 4300 | |
| for | 4083 | |
| problem | 2371 | 7.8% |
| check | 1207 | 4.0% |
| up | 1207 | 4.0% |
| patient | 1070 | 3.5% |
| of | 981 | 3.2% |
| visit | 902 | 3.0% |
| general | 843 | 2.8% |
| Other values (78) | 6695 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 30045 | |
| r | 27954 | |
| 23175 | 9.4% | |
| o | 21745 | 8.8% |
| n | 15908 | 6.5% |
| c | 15548 | 6.3% |
| u | 12810 | 5.2% |
| p | 12372 | 5.0% |
| t | 12290 | 5.0% |
| i | 8574 | 3.5% |
| Other values (34) | 66172 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 246593 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 30045 | |
| r | 27954 | |
| 23175 | 9.4% | |
| o | 21745 | 8.8% |
| n | 15908 | 6.5% |
| c | 15548 | 6.3% |
| u | 12810 | 5.2% |
| p | 12372 | 5.0% |
| t | 12290 | 5.0% |
| i | 8574 | 3.5% |
| Other values (34) | 66172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 246593 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 30045 | |
| r | 27954 | |
| 23175 | 9.4% | |
| o | 21745 | 8.8% |
| n | 15908 | 6.5% |
| c | 15548 | 6.3% |
| u | 12810 | 5.2% |
| p | 12372 | 5.0% |
| t | 12290 | 5.0% |
| i | 8574 | 3.5% |
| Other values (34) | 66172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 246593 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 30045 | |
| r | 27954 | |
| 23175 | 9.4% | |
| o | 21745 | 8.8% |
| n | 15908 | 6.5% |
| c | 15548 | 6.3% |
| u | 12810 | 5.2% |
| p | 12372 | 5.0% |
| t | 12290 | 5.0% |
| i | 8574 | 3.5% |
| Other values (34) | 66172 |
base_encounter_cost
Real number (ℝ)
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 108.44756 |
| Minimum | 75 |
|---|---|
| Maximum | 146.18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 75 |
|---|---|
| 5-th percentile | 85.55 |
| Q1 | 85.55 |
| median | 85.55 |
| Q3 | 136.8 |
| 95-th percentile | 142.58 |
| Maximum | 146.18 |
| Range | 71.18 |
| Interquartile range (IQR) | 51.25 |
Descriptive statistics
| Standard deviation | 27.050623 |
|---|---|
| Coefficient of variation (CV) | 0.24943507 |
| Kurtosis | -1.8477948 |
| Mean | 108.44756 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.35037511 |
| Sum | 764446.83 |
| Variance | 731.73623 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85.55 | 4042 | |
| 142.58 | 1372 | 19.5% |
| 136.8 | 1281 | 18.2% |
| 146.18 | 258 | 3.7% |
| 87.71 | 44 | 0.6% |
| 128.53 | 21 | 0.3% |
| 110.92 | 11 | 0.2% |
| 137.53 | 8 | 0.1% |
| 75 | 6 | 0.1% |
| 125 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 75 | 6 | 0.1% |
| 85.55 | 4042 | |
| 87.71 | 44 | 0.6% |
| 110.92 | 11 | 0.2% |
| 125 | 6 | 0.1% |
| 128.53 | 21 | 0.3% |
| 136.8 | 1281 | 18.2% |
| 137.53 | 8 | 0.1% |
| 142.58 | 1372 | 19.5% |
| 146.18 | 258 | 3.7% |
| Value | Count | Frequency (%) |
| 146.18 | 258 | 3.7% |
| 142.58 | 1372 | 19.5% |
| 137.53 | 8 | 0.1% |
| 136.8 | 1281 | 18.2% |
| 128.53 | 21 | 0.3% |
| 125 | 6 | 0.1% |
| 110.92 | 11 | 0.2% |
| 87.71 | 44 | 0.6% |
| 85.55 | 4042 | |
| 75 | 6 | 0.1% |
total_claim_cost
Real number (ℝ)
High correlation 
| Distinct | 2317 |
|---|---|
| Distinct (%) | 32.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2236.3992 |
| Minimum | 75 |
|---|---|
| Maximum | 67764.63 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 75 |
|---|---|
| 5-th percentile | 85.55 |
| Q1 | 535.87 |
| median | 879.52 |
| Q3 | 1791.03 |
| 95-th percentile | 9605.398 |
| Maximum | 67764.63 |
| Range | 67689.63 |
| Interquartile range (IQR) | 1255.16 |
Descriptive statistics
| Standard deviation | 4834.4294 |
|---|---|
| Coefficient of variation (CV) | 2.1617023 |
| Kurtosis | 56.253927 |
| Mean | 2236.3992 |
| Median Absolute Deviation (MAD) | 491.45 |
| Skewness | 6.5009818 |
| Sum | 15764378 |
| Variance | 23371708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 535.87 | 707 | 10.0% |
| 85.55 | 375 | 5.3% |
| 234.71 | 322 | 4.6% |
| 1791.03 | 232 | 3.3% |
| 3105.35 | 220 | 3.1% |
| 704.2 | 176 | 2.5% |
| 3536.75 | 172 | 2.4% |
| 142.58 | 141 | 2.0% |
| 516.95 | 140 | 2.0% |
| 278.58 | 138 | 2.0% |
| Other values (2307) | 4426 |
| Value | Count | Frequency (%) |
| 75 | 1 | < 0.1% |
| 85.55 | 375 | |
| 87.71 | 20 | 0.3% |
| 92.93 | 18 | 0.3% |
| 120.06 | 3 | < 0.1% |
| 128.94 | 1 | < 0.1% |
| 136.13 | 1 | < 0.1% |
| 136.8 | 22 | 0.3% |
| 142.58 | 141 | 2.0% |
| 146.18 | 79 | 1.1% |
| Value | Count | Frequency (%) |
| 67764.63 | 1 | |
| 66384.16 | 1 | |
| 59855.16 | 1 | |
| 57848.21 | 1 | |
| 56814.68 | 1 | |
| 55941.6 | 1 | |
| 54058.11 | 1 | |
| 53912.98 | 1 | |
| 53540.6 | 1 | |
| 53025.01 | 1 |
payer_coverage
Real number (ℝ)
High correlation  Zeros 
| Distinct | 2405 |
|---|---|
| Distinct (%) | 34.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1541.4883 |
| Minimum | 0 |
|---|---|
| Maximum | 56814.68 |
| Zeros | 1930 |
| Zeros (%) | 27.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 436.6 |
| Q3 | 1103.8 |
| 95-th percentile | 7838.588 |
| Maximum | 56814.68 |
| Range | 56814.68 |
| Interquartile range (IQR) | 1103.8 |
Descriptive statistics
| Standard deviation | 3869.6898 |
|---|---|
| Coefficient of variation (CV) | 2.5103595 |
| Kurtosis | 56.916004 |
| Mean | 1541.4883 |
| Median Absolute Deviation (MAD) | 436.6 |
| Skewness | 6.3081185 |
| Sum | 10865951 |
| Variance | 14974499 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1930 | |
| 428.7 | 605 | 8.6% |
| 187.76 | 228 | 3.2% |
| 1432.82 | 187 | 2.7% |
| 2484.28 | 83 | 1.2% |
| 68.44 | 75 | 1.1% |
| 2829.4 | 61 | 0.9% |
| 535.87 | 45 | 0.6% |
| 35.55 | 44 | 0.6% |
| 413.56 | 37 | 0.5% |
| Other values (2395) | 3754 |
| Value | Count | Frequency (%) |
| 0 | 1930 | |
| 0.94 | 1 | < 0.1% |
| 2.06 | 1 | < 0.1% |
| 2.82 | 1 | < 0.1% |
| 3.83 | 1 | < 0.1% |
| 3.95 | 1 | < 0.1% |
| 6.58 | 1 | < 0.1% |
| 11.63 | 1 | < 0.1% |
| 12.46 | 1 | < 0.1% |
| 15.49 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 56814.68 | 1 | |
| 55891.6 | 1 | |
| 54211.38 | 1 | |
| 54008.11 | 1 | |
| 53107.32 | 1 | |
| 51188.06 | 1 | |
| 50101.53 | 1 | |
| 43721.15 | 1 | |
| 41113.3 | 1 | |
| 40941.51 | 1 |
reason_code
Text
| Distinct | 106 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 9.3620372 |
| Min length | 7 |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | Unknown |
| 3rd row | 125605004.0 |
| 4th row | 359817006.0 |
| 5th row | Unknown |
| Value | Count | Frequency (%) |
| unknown | 2436 | |
| 431857002.0 | 1162 | |
| 46177005.0 | 673 | 9.5% |
| 72892002.0 | 392 | 5.6% |
| 103697008.0 | 325 | 4.6% |
| 389095005.0 | 323 | 4.6% |
| 66383009.0 | 317 | 4.5% |
| 254837009.0 | 158 | 2.2% |
| 444814009.0 | 91 | 1.3% |
| 82423001.0 | 83 | 1.2% |
| Other values (96) | 1089 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15075 | |
| n | 7308 | |
| . | 4613 | 7.0% |
| 7 | 4121 | 6.2% |
| 2 | 3573 | 5.4% |
| 5 | 3435 | 5.2% |
| 1 | 3363 | 5.1% |
| 8 | 3289 | 5.0% |
| 3 | 3195 | 4.8% |
| 4 | 3026 | 4.6% |
| Other values (6) | 14995 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65993 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15075 | |
| n | 7308 | |
| . | 4613 | 7.0% |
| 7 | 4121 | 6.2% |
| 2 | 3573 | 5.4% |
| 5 | 3435 | 5.2% |
| 1 | 3363 | 5.1% |
| 8 | 3289 | 5.0% |
| 3 | 3195 | 4.8% |
| 4 | 3026 | 4.6% |
| Other values (6) | 14995 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65993 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15075 | |
| n | 7308 | |
| . | 4613 | 7.0% |
| 7 | 4121 | 6.2% |
| 2 | 3573 | 5.4% |
| 5 | 3435 | 5.2% |
| 1 | 3363 | 5.1% |
| 8 | 3289 | 5.0% |
| 3 | 3195 | 4.8% |
| 4 | 3026 | 4.6% |
| Other values (6) | 14995 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65993 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15075 | |
| n | 7308 | |
| . | 4613 | 7.0% |
| 7 | 4121 | 6.2% |
| 2 | 3573 | 5.4% |
| 5 | 3435 | 5.2% |
| 1 | 3363 | 5.1% |
| 8 | 3289 | 5.0% |
| 3 | 3195 | 4.8% |
| 4 | 3026 | 4.6% |
| Other values (6) | 14995 |
| Distinct | 106 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
Length
| Max length | 78 |
|---|---|
| Median length | 76 |
| Mean length | 25.039722 |
| Min length | 7 |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | Unknown |
| 3rd row | Fracture of bone (disorder) |
| 4th row | Closed fracture of hip (disorder) |
| 5th row | Unknown |
| Value | Count | Frequency (%) |
| disorder | 3290 | |
| unknown | 2436 | 10.8% |
| disease | 1870 | 8.3% |
| chronic | 1267 | 5.6% |
| kidney | 1173 | 5.2% |
| 4 | 1162 | 5.2% |
| stage | 1162 | 5.2% |
| care | 694 | 3.1% |
| renal | 689 | 3.1% |
| end-stage | 673 | 3.0% |
| Other values (204) | 8112 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 17595 | 10.0% |
| n | 16890 | 9.6% |
| 15486 | 8.8% | |
| r | 14680 | 8.3% |
| i | 13629 | 7.7% |
| d | 12080 | 6.8% |
| s | 11167 | 6.3% |
| o | 10516 | 6.0% |
| a | 9903 | 5.6% |
| t | 6612 | 3.7% |
| Other values (44) | 47947 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 176505 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 17595 | 10.0% |
| n | 16890 | 9.6% |
| 15486 | 8.8% | |
| r | 14680 | 8.3% |
| i | 13629 | 7.7% |
| d | 12080 | 6.8% |
| s | 11167 | 6.3% |
| o | 10516 | 6.0% |
| a | 9903 | 5.6% |
| t | 6612 | 3.7% |
| Other values (44) | 47947 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 176505 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 17595 | 10.0% |
| n | 16890 | 9.6% |
| 15486 | 8.8% | |
| r | 14680 | 8.3% |
| i | 13629 | 7.7% |
| d | 12080 | 6.8% |
| s | 11167 | 6.3% |
| o | 10516 | 6.0% |
| a | 9903 | 5.6% |
| t | 6612 | 3.7% |
| Other values (44) | 47947 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 176505 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 17595 | 10.0% |
| n | 16890 | 9.6% |
| 15486 | 8.8% | |
| r | 14680 | 8.3% |
| i | 13629 | 7.7% |
| d | 12080 | 6.8% |
| s | 11167 | 6.3% |
| o | 10516 | 6.0% |
| a | 9903 | 5.6% |
| t | 6612 | 3.7% |
| Other values (44) | 47947 |
length_of_stay_hours
Real number (ℝ)
Skewed 
| Distinct | 2362 |
|---|---|
| Distinct (%) | 33.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1367359 |
| Minimum | 0.25 |
|---|---|
| Maximum | 1464.25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 0.25 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 0.25 |
| median | 0.82472222 |
| Q3 | 2.7666667 |
| 95-th percentile | 3.9166667 |
| Maximum | 1464.25 |
| Range | 1464 |
| Interquartile range (IQR) | 2.5166667 |
Descriptive statistics
| Standard deviation | 28.096415 |
|---|---|
| Coefficient of variation (CV) | 8.9572141 |
| Kurtosis | 1290.9365 |
| Mean | 3.1367359 |
| Median Absolute Deviation (MAD) | 0.57472222 |
| Skewness | 31.335771 |
| Sum | 22110.852 |
| Variance | 789.40856 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.25 | 2075 | |
| 1 | 253 | 3.6% |
| 24 | 27 | 0.4% |
| 3.05 | 26 | 0.4% |
| 2.433333333 | 23 | 0.3% |
| 3.233333333 | 22 | 0.3% |
| 3.266666667 | 22 | 0.3% |
| 2.4 | 21 | 0.3% |
| 3.7 | 21 | 0.3% |
| 2.733333333 | 21 | 0.3% |
| Other values (2352) | 4538 |
| Value | Count | Frequency (%) |
| 0.25 | 2075 | |
| 0.2511111111 | 1 | < 0.1% |
| 0.2513888889 | 1 | < 0.1% |
| 0.2516666667 | 1 | < 0.1% |
| 0.2522222222 | 1 | < 0.1% |
| 0.2527777778 | 1 | < 0.1% |
| 0.2533333333 | 1 | < 0.1% |
| 0.2541666667 | 1 | < 0.1% |
| 0.2544444444 | 1 | < 0.1% |
| 0.2547222222 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1464.25 | 1 | < 0.1% |
| 816.25 | 1 | < 0.1% |
| 720.25 | 1 | < 0.1% |
| 624 | 1 | < 0.1% |
| 591.0502778 | 1 | < 0.1% |
| 528 | 1 | < 0.1% |
| 336.25 | 1 | < 0.1% |
| 312.7402778 | 1 | < 0.1% |
| 312.25 | 3 | |
| 275.5919444 | 1 | < 0.1% |
birthdate
Date
| Distinct | 100 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| Minimum | 1914-03-03 00:00:00 |
|---|---|
| Maximum | 2023-03-01 00:00:00 |
marital
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| M | |
|---|---|
| Unknown | |
| D | |
| S | |
| W | 176 |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 2.2188963 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 3670 | |
| Unknown | 1432 | 20.3% |
| D | 1169 | 16.6% |
| S | 602 | 8.5% |
| W | 176 | 2.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 3670 | |
| unknown | 1432 | 20.3% |
| d | 1169 | 16.6% |
| s | 602 | 8.5% |
| w | 176 | 2.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 4296 | |
| M | 3670 | |
| U | 1432 | 9.2% |
| k | 1432 | 9.2% |
| o | 1432 | 9.2% |
| w | 1432 | 9.2% |
| D | 1169 | 7.5% |
| S | 602 | 3.8% |
| W | 176 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15641 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 4296 | |
| M | 3670 | |
| U | 1432 | 9.2% |
| k | 1432 | 9.2% |
| o | 1432 | 9.2% |
| w | 1432 | 9.2% |
| D | 1169 | 7.5% |
| S | 602 | 3.8% |
| W | 176 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15641 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 4296 | |
| M | 3670 | |
| U | 1432 | 9.2% |
| k | 1432 | 9.2% |
| o | 1432 | 9.2% |
| w | 1432 | 9.2% |
| D | 1169 | 7.5% |
| S | 602 | 3.8% |
| W | 176 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15641 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 4296 | |
| M | 3670 | |
| U | 1432 | 9.2% |
| k | 1432 | 9.2% |
| o | 1432 | 9.2% |
| w | 1432 | 9.2% |
| D | 1169 | 7.5% |
| S | 602 | 3.8% |
| W | 176 | 1.1% |
race
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| white | |
|---|---|
| asian | |
| other | 484 |
| black | 249 |
| native | 27 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.0038303 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | white |
|---|---|
| 2nd row | white |
| 3rd row | white |
| 4th row | white |
| 5th row | white |
Common Values
| Value | Count | Frequency (%) |
| white | 5191 | |
| asian | 1098 | 15.6% |
| other | 484 | 6.9% |
| black | 249 | 3.5% |
| native | 27 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| white | 5191 | |
| asian | 1098 | 15.6% |
| other | 484 | 6.9% |
| black | 249 | 3.5% |
| native | 27 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 6316 | |
| e | 5702 | |
| t | 5702 | |
| h | 5675 | |
| w | 5191 | |
| a | 2472 | 7.0% |
| n | 1125 | 3.2% |
| s | 1098 | 3.1% |
| o | 484 | 1.4% |
| r | 484 | 1.4% |
| Other values (5) | 1023 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 35272 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 6316 | |
| e | 5702 | |
| t | 5702 | |
| h | 5675 | |
| w | 5191 | |
| a | 2472 | 7.0% |
| n | 1125 | 3.2% |
| s | 1098 | 3.1% |
| o | 484 | 1.4% |
| r | 484 | 1.4% |
| Other values (5) | 1023 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 35272 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 6316 | |
| e | 5702 | |
| t | 5702 | |
| h | 5675 | |
| w | 5191 | |
| a | 2472 | 7.0% |
| n | 1125 | 3.2% |
| s | 1098 | 3.1% |
| o | 484 | 1.4% |
| r | 484 | 1.4% |
| Other values (5) | 1023 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 35272 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 6316 | |
| e | 5702 | |
| t | 5702 | |
| h | 5675 | |
| w | 5191 | |
| a | 2472 | 7.0% |
| n | 1125 | 3.2% |
| s | 1098 | 3.1% |
| o | 484 | 1.4% |
| r | 484 | 1.4% |
| Other values (5) | 1023 | 2.9% |
ethnicity
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| nonhispanic | |
|---|---|
| hispanic |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.717832 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | nonhispanic |
|---|---|
| 2nd row | nonhispanic |
| 3rd row | nonhispanic |
| 4th row | nonhispanic |
| 5th row | nonhispanic |
Common Values
| Value | Count | Frequency (%) |
| nonhispanic | 6386 | |
| hispanic | 663 | 9.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| nonhispanic | 6386 | |
| hispanic | 663 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 19821 | |
| i | 14098 | |
| h | 7049 | 9.3% |
| s | 7049 | 9.3% |
| a | 7049 | 9.3% |
| p | 7049 | 9.3% |
| c | 7049 | 9.3% |
| o | 6386 | 8.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 75550 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 19821 | |
| i | 14098 | |
| h | 7049 | 9.3% |
| s | 7049 | 9.3% |
| a | 7049 | 9.3% |
| p | 7049 | 9.3% |
| c | 7049 | 9.3% |
| o | 6386 | 8.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 75550 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 19821 | |
| i | 14098 | |
| h | 7049 | 9.3% |
| s | 7049 | 9.3% |
| a | 7049 | 9.3% |
| p | 7049 | 9.3% |
| c | 7049 | 9.3% |
| o | 6386 | 8.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 75550 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 19821 | |
| i | 14098 | |
| h | 7049 | 9.3% |
| s | 7049 | 9.3% |
| a | 7049 | 9.3% |
| p | 7049 | 9.3% |
| c | 7049 | 9.3% |
| o | 6386 | 8.5% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| F | 3736 | |
| M | 3313 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 3736 | |
| m | 3313 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 3736 | |
| M | 3313 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7049 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| F | 3736 | |
| M | 3313 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7049 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| F | 3736 | |
| M | 3313 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7049 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| F | 3736 | |
| M | 3313 |
income
Real number (ℝ)
High correlation 
| Distinct | 100 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 111813.19 |
| Minimum | 7361 |
|---|---|
| Maximum | 816851 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 7361 |
|---|---|
| 5-th percentile | 16969 |
| Q1 | 61016 |
| median | 90297 |
| Q3 | 118047 |
| 95-th percentile | 189277 |
| Maximum | 816851 |
| Range | 809490 |
| Interquartile range (IQR) | 57031 |
Descriptive statistics
| Standard deviation | 125542.18 |
|---|---|
| Coefficient of variation (CV) | 1.122785 |
| Kurtosis | 18.539338 |
| Mean | 111813.19 |
| Median Absolute Deviation (MAD) | 27965 |
| Skewness | 4.1059595 |
| Sum | 7.8817121 × 108 |
| Variance | 1.5760839 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 92537 | 750 | 10.6% |
| 189277 | 700 | 9.9% |
| 82922 | 546 | 7.7% |
| 90297 | 460 | 6.5% |
| 63727 | 252 | 3.6% |
| 35860 | 248 | 3.5% |
| 118047 | 243 | 3.4% |
| 95344 | 157 | 2.2% |
| 72413 | 141 | 2.0% |
| 742063 | 115 | 1.6% |
| Other values (90) | 3437 |
| Value | Count | Frequency (%) |
| 7361 | 90 | |
| 7873 | 17 | 0.2% |
| 8615 | 56 | |
| 8752 | 45 | |
| 10135 | 11 | 0.2% |
| 10682 | 40 | |
| 12128 | 44 | |
| 16969 | 61 | |
| 17382 | 72 | |
| 18258 | 31 | 0.4% |
| Value | Count | Frequency (%) |
| 816851 | 56 | 0.8% |
| 762068 | 24 | 0.3% |
| 742063 | 115 | 1.6% |
| 550030 | 27 | 0.4% |
| 545255 | 8 | 0.1% |
| 198522 | 28 | 0.4% |
| 198442 | 34 | 0.5% |
| 189277 | 700 | |
| 188023 | 77 | 1.1% |
| 179090 | 68 | 1.0% |
income_category
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| high-income | |
|---|---|
| medium-income | |
| low-income |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.307987 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | high-income |
|---|---|
| 2nd row | high-income |
| 3rd row | high-income |
| 4th row | high-income |
| 5th row | high-income |
Common Values
| Value | Count | Frequency (%) |
| high-income | 3721 | |
| medium-income | 1833 | |
| low-income | 1495 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| high-income | 3721 | |
| medium-income | 1833 | |
| low-income | 1495 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 12603 | |
| m | 10715 | |
| e | 8882 | |
| o | 8544 | |
| h | 7442 | |
| - | 7049 | |
| n | 7049 | |
| c | 7049 | |
| g | 3721 | 4.7% |
| d | 1833 | 2.3% |
| Other values (3) | 4823 | 6.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79710 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 12603 | |
| m | 10715 | |
| e | 8882 | |
| o | 8544 | |
| h | 7442 | |
| - | 7049 | |
| n | 7049 | |
| c | 7049 | |
| g | 3721 | 4.7% |
| d | 1833 | 2.3% |
| Other values (3) | 4823 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79710 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 12603 | |
| m | 10715 | |
| e | 8882 | |
| o | 8544 | |
| h | 7442 | |
| - | 7049 | |
| n | 7049 | |
| c | 7049 | |
| g | 3721 | 4.7% |
| d | 1833 | 2.3% |
| Other values (3) | 4823 | 6.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79710 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 12603 | |
| m | 10715 | |
| e | 8882 | |
| o | 8544 | |
| h | 7442 | |
| - | 7049 | |
| n | 7049 | |
| c | 7049 | |
| g | 3721 | 4.7% |
| d | 1833 | 2.3% |
| Other values (3) | 4823 | 6.1% |
age_of_patient
Real number (ℝ)
High correlation 
| Distinct | 4749 |
|---|---|
| Distinct (%) | 67.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.005397 |
| Minimum | 0 |
|---|---|
| Maximum | 110.04384 |
| Zeros | 11 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.769863 |
| Q1 | 25.871233 |
| median | 49.134247 |
| Q3 | 67.775342 |
| 95-th percentile | 79.547397 |
| Maximum | 110.04384 |
| Range | 110.04384 |
| Interquartile range (IQR) | 41.90411 |
Descriptive statistics
| Standard deviation | 23.919491 |
|---|---|
| Coefficient of variation (CV) | 0.5088669 |
| Kurtosis | -1.026738 |
| Mean | 47.005397 |
| Median Absolute Deviation (MAD) | 19.739726 |
| Skewness | -0.25318775 |
| Sum | 331341.05 |
| Variance | 572.14204 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.16164384 | 73 | 1.0% |
| 19.17808219 | 28 | 0.4% |
| 22.1890411 | 27 | 0.4% |
| 12.0630137 | 23 | 0.3% |
| 9.01369863 | 22 | 0.3% |
| 11.04657534 | 22 | 0.3% |
| 17.14520548 | 21 | 0.3% |
| 13.07945205 | 21 | 0.3% |
| 10.03013699 | 20 | 0.3% |
| 25.2 | 20 | 0.3% |
| Other values (4739) | 6772 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 0.05479452055 | 1 | < 0.1% |
| 0.09589041096 | 11 | |
| 0.101369863 | 1 | < 0.1% |
| 0.1150684932 | 1 | < 0.1% |
| 0.2465753425 | 1 | < 0.1% |
| 0.2684931507 | 12 | |
| 0.4410958904 | 12 | |
| 0.4602739726 | 1 | < 0.1% |
| 0.4931506849 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 110.0438356 | 1 | |
| 110.0054795 | 1 | |
| 108.9890411 | 1 | |
| 108.6876712 | 1 | |
| 108.0109589 | 1 | |
| 107.9726027 | 1 | |
| 107.6931507 | 2 | |
| 107.3780822 | 1 | |
| 107.339726 | 1 | |
| 107.309589 | 1 |
age_category
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 KiB |
| adult | |
|---|---|
| senior | |
| children |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.7320187 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | adult |
|---|---|
| 2nd row | adult |
| 3rd row | adult |
| 4th row | adult |
| 5th row | adult |
Common Values
| Value | Count | Frequency (%) |
| adult | 3979 | |
| senior | 2025 | |
| children | 1045 | 14.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| adult | 3979 | |
| senior | 2025 | |
| children | 1045 | 14.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 5024 | |
| l | 5024 | |
| a | 3979 | |
| u | 3979 | |
| t | 3979 | |
| e | 3070 | |
| n | 3070 | |
| i | 3070 | |
| r | 3070 | |
| s | 2025 | |
| Other values (3) | 4115 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40405 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| d | 5024 | |
| l | 5024 | |
| a | 3979 | |
| u | 3979 | |
| t | 3979 | |
| e | 3070 | |
| n | 3070 | |
| i | 3070 | |
| r | 3070 | |
| s | 2025 | |
| Other values (3) | 4115 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40405 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| d | 5024 | |
| l | 5024 | |
| a | 3979 | |
| u | 3979 | |
| t | 3979 | |
| e | 3070 | |
| n | 3070 | |
| i | 3070 | |
| r | 3070 | |
| s | 2025 | |
| Other values (3) | 4115 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40405 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| d | 5024 | |
| l | 5024 | |
| a | 3979 | |
| u | 3979 | |
| t | 3979 | |
| e | 3070 | |
| n | 3070 | |
| i | 3070 | |
| r | 3070 | |
| s | 2025 | |
| Other values (3) | 4115 |
Interactions
Correlations
| age_category | age_of_patient | base_encounter_cost | code | description | encounter_class | ethnicity | gender | income | income_category | length_of_stay_hours | marital | payer_coverage | payer_id | race | total_claim_cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| age_category | 1.000 | 0.909 | 0.281 | 0.575 | 0.575 | 0.242 | 0.213 | 0.271 | 0.328 | 0.200 | 0.018 | 0.620 | 0.092 | 0.504 | 0.317 | 0.096 |
| age_of_patient | 0.909 | 1.000 | -0.366 | -0.164 | 0.320 | 0.152 | 0.331 | 0.489 | 0.220 | 0.340 | 0.410 | 0.540 | 0.246 | 0.314 | 0.486 | -0.063 |
| base_encounter_cost | 0.281 | -0.366 | 1.000 | 0.173 | 0.824 | 0.861 | 0.172 | 0.211 | -0.091 | 0.134 | -0.428 | 0.168 | 0.003 | 0.197 | 0.121 | 0.169 |
| code | 0.575 | -0.164 | 0.173 | 1.000 | 1.000 | 0.879 | 0.299 | 0.366 | 0.012 | 0.262 | -0.218 | 0.353 | 0.162 | 0.250 | 0.234 | 0.211 |
| description | 0.575 | 0.320 | 0.824 | 1.000 | 1.000 | 0.879 | 0.299 | 0.366 | 0.226 | 0.262 | 0.453 | 0.353 | 0.372 | 0.250 | 0.234 | 0.444 |
| encounter_class | 0.242 | 0.152 | 0.861 | 0.879 | 0.879 | 1.000 | 0.112 | 0.131 | 0.129 | 0.148 | 0.410 | 0.157 | 0.092 | 0.135 | 0.126 | 0.103 |
| ethnicity | 0.213 | 0.331 | 0.172 | 0.299 | 0.299 | 0.112 | 1.000 | 0.152 | 0.215 | 0.058 | 0.000 | 0.161 | 0.131 | 0.335 | 0.174 | 0.117 |
| gender | 0.271 | 0.489 | 0.211 | 0.366 | 0.366 | 0.131 | 0.152 | 1.000 | 0.464 | 0.203 | 0.018 | 0.327 | 0.148 | 0.340 | 0.440 | 0.148 |
| income | 0.328 | 0.220 | -0.091 | 0.012 | 0.226 | 0.129 | 0.215 | 0.464 | 1.000 | 0.707 | 0.103 | 0.211 | 0.035 | 0.420 | 0.283 | -0.004 |
| income_category | 0.200 | 0.340 | 0.134 | 0.262 | 0.262 | 0.148 | 0.058 | 0.203 | 0.707 | 1.000 | 0.000 | 0.217 | 0.048 | 0.606 | 0.254 | 0.041 |
| length_of_stay_hours | 0.018 | 0.410 | -0.428 | -0.218 | 0.453 | 0.410 | 0.000 | 0.018 | 0.103 | 0.000 | 1.000 | 0.000 | 0.266 | 0.000 | 0.000 | 0.303 |
| marital | 0.620 | 0.540 | 0.168 | 0.353 | 0.353 | 0.157 | 0.161 | 0.327 | 0.211 | 0.217 | 0.000 | 1.000 | 0.047 | 0.310 | 0.312 | 0.059 |
| payer_coverage | 0.092 | 0.246 | 0.003 | 0.162 | 0.372 | 0.092 | 0.131 | 0.148 | 0.035 | 0.048 | 0.266 | 0.047 | 1.000 | 0.082 | 0.042 | 0.616 |
| payer_id | 0.504 | 0.314 | 0.197 | 0.250 | 0.250 | 0.135 | 0.335 | 0.340 | 0.420 | 0.606 | 0.000 | 0.310 | 0.082 | 1.000 | 0.247 | 0.073 |
| race | 0.317 | 0.486 | 0.121 | 0.234 | 0.234 | 0.126 | 0.174 | 0.440 | 0.283 | 0.254 | 0.000 | 0.312 | 0.042 | 0.247 | 1.000 | 0.041 |
| total_claim_cost | 0.096 | -0.063 | 0.169 | 0.211 | 0.444 | 0.103 | 0.117 | 0.148 | -0.004 | 0.041 | 0.303 | 0.059 | 0.616 | 0.073 | 0.041 | 1.000 |
Missing values
Sample
| encounter_id | start_time | stop_time | patient_id | organization_id | provider_id | payer_id | encounter_class | code | description | base_encounter_cost | total_claim_cost | payer_coverage | reason_code | reason_description | length_of_stay_hours | birthdate | marital | race | ethnicity | gender | income | income_category | age_of_patient | age_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 294d0dab-907e-8fce-7a47-0c0d322a5734 | 2012-04-01 09:04:48 | 2012-04-01 10:02:47 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | f2068cee-c75c-321d-9b2c-c33535db89c9 | c3d07214-c20f-3f33-ad41-0e55adf5b024 | d31fccc3-1767-390d-966a-22a5156f4219 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 1567.00 | 87.20 | Unknown | Unknown | 0.966389 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 18.161644 | adult |
| 1 | 2ccec874-cbaa-e280-7abb-f2bc2b603961 | 2013-04-07 09:04:48 | 2013-04-07 09:55:49 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | f2068cee-c75c-321d-9b2c-c33535db89c9 | c3d07214-c20f-3f33-ad41-0e55adf5b024 | d31fccc3-1767-390d-966a-22a5156f4219 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 704.20 | 0.00 | Unknown | Unknown | 0.850278 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 19.178082 | adult |
| 2 | 953c5138-ce17-4084-3432-1ac23f184528 | 2015-09-28 09:04:48 | 2015-09-28 11:02:48 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | db106514-f254-3402-b6a4-6d210c78c7e2 | 2c4b7d17-0ded-3e16-b5eb-6dda1d6a81bb | d31fccc3-1767-390d-966a-22a5156f4219 | emergency | 50849002 | Emergency room admission (procedure) | 146.18 | 1008.98 | 0.00 | 125605004.0 | Fracture of bone (disorder) | 1.966667 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 21.654795 | adult |
| 3 | 17dd3b88-0b85-2b6f-c342-c9d6cf5315cb | 2015-10-31 11:02:48 | 2015-10-31 11:17:48 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | f8918a95-31e8-3ac4-8d12-29ca6080ebda | b4d9fbc9-fdca-369d-bbba-019479923f08 | d31fccc3-1767-390d-966a-22a5156f4219 | ambulatory | 185349003 | Encounter for check up (procedure) | 85.55 | 85.55 | 3.95 | 359817006.0 | Closed fracture of hip (disorder) | 0.250000 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 21.745205 | adult |
| 4 | 0b03e41b-06a6-66fa-b972-acc5a83b134a | 2016-04-10 09:04:48 | 2016-04-10 10:00:45 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | f2068cee-c75c-321d-9b2c-c33535db89c9 | c3d07214-c20f-3f33-ad41-0e55adf5b024 | d31fccc3-1767-390d-966a-22a5156f4219 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 2039.18 | 464.94 | Unknown | Unknown | 0.932500 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 22.189041 | adult |
| 5 | 1617912a-d228-1f6c-ed9b-d8fb39ef0a32 | 2016-04-24 09:04:48 | 2016-04-24 11:43:25 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | f8918a95-31e8-3ac4-8d12-29ca6080ebda | b4d9fbc9-fdca-369d-bbba-019479923f08 | d31fccc3-1767-390d-966a-22a5156f4219 | ambulatory | 185349003 | Encounter for check up (procedure) | 85.55 | 3105.35 | 2484.28 | 66383009.0 | Gingivitis (disorder) | 2.643611 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 22.227397 | adult |
| 6 | 3606e65a-a4da-810c-ef6b-ddbf6da17952 | 1986-10-07 19:07:21 | 1986-10-07 19:38:44 | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | 69eae27b-7445-3652-bd34-b535abe0b011 | d9d8f8b4-ecbb-3cd1-be3e-96eb5b6058fc | e03e23c9-4df1-3eb6-a62d-f70f02301496 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 704.20 | 0.00 | Unknown | Unknown | 0.523056 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 18.180822 | adult |
| 7 | 24f50776-1be9-9789-ba60-03447528a47c | 1990-10-16 19:07:21 | 1990-10-16 19:54:58 | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | 9ed61c49-1d0c-3774-b528-d75b50938fe2 | e68afc41-8284-37b0-8584-3b07e32cc5ff | e03e23c9-4df1-3eb6-a62d-f70f02301496 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 1130.48 | 0.00 | Unknown | Unknown | 0.793611 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 22.208219 | adult |
| 8 | cc632c61-54a0-35f6-be9f-879875d14c4f | 1996-10-22 19:07:21 | 1996-10-22 19:48:17 | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | 9ed61c49-1d0c-3774-b528-d75b50938fe2 | e68afc41-8284-37b0-8584-3b07e32cc5ff | e03e23c9-4df1-3eb6-a62d-f70f02301496 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 1139.50 | 0.00 | Unknown | Unknown | 0.682222 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 28.230137 | adult |
| 9 | dd83e406-eae2-49dc-734e-06d34594f3df | 1999-10-26 19:07:21 | 1999-10-26 19:49:13 | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | 9ed61c49-1d0c-3774-b528-d75b50938fe2 | e68afc41-8284-37b0-8584-3b07e32cc5ff | e03e23c9-4df1-3eb6-a62d-f70f02301496 | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 996.16 | 0.00 | Unknown | Unknown | 0.697778 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 31.241096 | adult |
| encounter_id | start_time | stop_time | patient_id | organization_id | provider_id | payer_id | encounter_class | code | description | base_encounter_cost | total_claim_cost | payer_coverage | reason_code | reason_description | length_of_stay_hours | birthdate | marital | race | ethnicity | gender | income | income_category | age_of_patient | age_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7039 | 4eab68ea-1c42-edd6-c666-0a4d63cad726 | 2022-08-14 23:42:23 | 2022-08-14 23:57:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | be895734-2bc8-387a-8897-7023aee72926 | 1753cdbb-bc77-3db4-9bed-1e9de82bf81a | a735bf55-83e9-331a-899d-a82a60b9f60c | home | 439708006 | Home visit (procedure) | 128.53 | 559.93 | 447.94 | 1871000124103.0 | Transition from acute care to home-health care (finding) | 0.250000 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.775342 | senior |
| 7040 | 774b8459-cd26-5ac2-bef3-f017d628b488 | 2022-08-15 23:42:23 | 2022-08-15 23:57:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | be895734-2bc8-387a-8897-7023aee72926 | 1753cdbb-bc77-3db4-9bed-1e9de82bf81a | a735bf55-83e9-331a-899d-a82a60b9f60c | home | 439708006 | Home visit (procedure) | 128.53 | 991.33 | 793.06 | 1871000124103.0 | Transition from acute care to home-health care (finding) | 0.250000 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.778082 | senior |
| 7041 | 5db88eb9-408d-acaa-779e-e81fd70e81ec | 2022-09-01 09:25:23 | 2022-09-01 10:06:37 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 936ceb96-2b12-371f-aa68-ee02a9c06f4c | 6521da89-0296-38bd-b158-83ac049f380a | a735bf55-83e9-331a-899d-a82a60b9f60c | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 1291.56 | 1033.24 | Unknown | Unknown | 0.687222 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.824658 | senior |
| 7042 | 94cc3e70-aa21-8b87-b0c5-f7d12dafdd7b | 2022-09-15 09:25:23 | 2022-09-15 15:23:15 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 0fedae9f-701f-3317-9b2f-69aea2202cdc | 7c355076-7f52-398a-be6e-e77e8104c27c | a735bf55-83e9-331a-899d-a82a60b9f60c | ambulatory | 185349003 | Encounter for check up (procedure) | 85.55 | 4830.95 | 3864.76 | 66383009.0 | Gingivitis (disorder) | 5.964444 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.863014 | senior |
| 7043 | e3dfa401-6793-85f8-e430-bffb4d0aec1c | 2023-09-07 09:25:23 | 2023-09-07 10:25:17 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 936ceb96-2b12-371f-aa68-ee02a9c06f4c | 6521da89-0296-38bd-b158-83ac049f380a | a735bf55-83e9-331a-899d-a82a60b9f60c | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 914.78 | 546.52 | Unknown | Unknown | 0.998333 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 71.841096 | senior |
| 7044 | f78b6556-fbfe-8cfe-1eec-48fb7eabf0df | 2023-09-14 09:25:23 | 2023-09-14 10:42:09 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 0fedae9f-701f-3317-9b2f-69aea2202cdc | 7c355076-7f52-398a-be6e-e77e8104c27c | a735bf55-83e9-331a-899d-a82a60b9f60c | ambulatory | 185347001 | Encounter for problem (procedure) | 85.55 | 1379.75 | 1103.80 | 37320007.0 | Loss of teeth (disorder) | 1.279444 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 71.860274 | senior |
| 7045 | 6024e199-9bdd-7ada-8ffb-a53ab3eb106d | 2023-09-28 10:42:09 | 2023-09-28 11:18:58 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 0fedae9f-701f-3317-9b2f-69aea2202cdc | 7c355076-7f52-398a-be6e-e77e8104c27c | a735bf55-83e9-331a-899d-a82a60b9f60c | ambulatory | 390906007 | Follow-up encounter (procedure) | 85.55 | 516.95 | 413.56 | 37320007.0 | Loss of teeth (disorder) | 0.613611 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 71.898630 | senior |
| 7046 | 03a0d6f1-5131-1f41-35bb-c965b63a3ebd | 2024-04-14 09:25:23 | 2024-04-14 10:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | fe30f2b4-9bc8-346e-afba-4455d1766545 | 24c044b1-9803-3ce7-8bf4-4222e4ea7074 | a735bf55-83e9-331a-899d-a82a60b9f60c | emergency | 32485007 | Hospital admission (procedure) | 146.18 | 146.18 | 0.00 | 95417003.0 | Primary fibromyalgia syndrome (disorder) | 1.000000 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 72.443836 | senior |
| 7047 | 3f31f856-ac64-df94-45b2-9710c15536f8 | 2024-09-12 09:25:23 | 2024-09-12 10:13:03 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 936ceb96-2b12-371f-aa68-ee02a9c06f4c | 6521da89-0296-38bd-b158-83ac049f380a | a735bf55-83e9-331a-899d-a82a60b9f60c | wellness | 162673000 | General examination of patient (procedure) | 136.80 | 1816.64 | 1387.55 | Unknown | Unknown | 0.794444 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 72.857534 | senior |
| 7048 | 8fb043ba-08be-2a3a-1011-c3019f2b7d07 | 2024-09-26 09:25:23 | 2024-09-26 16:31:42 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | 0fedae9f-701f-3317-9b2f-69aea2202cdc | 7c355076-7f52-398a-be6e-e77e8104c27c | a735bf55-83e9-331a-899d-a82a60b9f60c | ambulatory | 185349003 | Encounter for check up (procedure) | 85.55 | 4830.95 | 3864.76 | 66383009.0 | Gingivitis (disorder) | 7.105278 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 72.895890 | senior |